<?session_start();
$usuario = $_SESSION['usuario'];?><body link = "white" alink = "white" vlink = "white" text = "white">
<?include ("../conectarse.php");
$consultaid = "select * from inversores where inv_dni like $usuario";
$resultadoid = mysql_query($consultaid);

$filaid = mysql_fetch_array($resultadoid);

$idconsultor = $filaid['inv_id'];?>
<center><table width = "500" height = "100%" BORDER = "0" cellspacing = "0" cellpadding = "0" valign = "top" background = "fondotexto2.png"><tr><td><table height = "100%" width = "100%">


<tr><td align = "center"   background = "fondotexto.png" >
<hr><CENTER><B>CARPETAS<hr>
</td></tr>
<tr valign = "top" height = "100%"><td>
<table cellspacing = "0" cellpadding = "0" border = "1" width = "100%"><tr><tD>
<center>&nbsp;</center><hr>

</td></tr></table>
<table cellspacing = "0" cellpadding = "0" border = "1" width = "100%"><tr><tD>

<table width = "100%"><tr><td align = "center">
<center>&nbsp;</center>
<hr>







<TABLE width = "1024" border = "0" cellspacing = "0" cellpadding = "0"><TR  background = "fondotexto.png" bgcolor = "white">


<TD align = "left"><B>NOMBRE</B></TD>
<TD align = "left"><B>APELLIDO</B></TD>
<TD align = "left"><B>DOCUMENTO</B></TD>

<TD align = "left"><B>NOMBRE R.</B></TD>

<TD align = "left"><B>APELLIDO R.</B></TD>

<TD align = "left"><B>VINCULO R.</B></TD>

<TD align = "left"><B>FIJO R.</B></TD>



<TD align = "left"><B>IMPORTE</B></TD>



</tr>

<?$consulta = "select * from prestamos, solicitantes where prestamos.pres_id_solicitante = solicitantes.sol_id";
$resultado = mysql_query($consulta);

while($fila=mysql_fetch_array($resultado)){?>
<TR  background = "fondotexto2.png" bgcolor = "white">


<TD align = "left"><font color = "black"><B><?echo $fila['sol_nombre'];?></B></TD>
<TD align = "left"><font color = "black"><B><?echo $fila['sol_apellido'];?></B></TD>
<TD align = "left"><font color = "black"><B><?echo $fila['sol_nro_doc'];?></B></TD>

<TD align = "left"><font color = "black"><B><?echo $fila['sol_referencia_nombre'];?></B></TD>

<TD align = "left"><font color = "black"><B><?echo $fila['sol_referencia_apellido'];?></B></TD>

<TD align = "left"><font color = "black"><B><?echo $fila['sol_vinculo'];?></B></TD>

<TD align = "left"><font color = "black"><B><?echo $fila['sol_referencia_telefono'];?></B></TD>



<TD align = "left"><font color = "black"><B><?echo $fila['pres_importe'];?></B></TD>



</tr>

<?}?>

</table>






























</td></tr></table><BR><CENTER></form><form action = "index.php"><INPUT TYPE = "SUBMIT" VALUE = "CERRAR"></CENTER>
</td></tr></table></td></tr></table>